www.gusucode.com > PHP版 QQ聊天机器人源码 V3.2PHP源码程序 > PHP版 QQ聊天机器人源码 V3.2/Itpk_V3.2_Zip/Itpk_V3.2_Zip/class/per/WebrolePer.php
<?php if (!defined('ITPK')) exit('You can not directly access the file.'); /** * 用户组操作类 * @author 冬天的秘密 * @link http://bbs.itpk.cn * @version 1.0 */ class WebrolePer extends WebDBConnection { private $table = "web_role"; /** * 根据用户组ID获取信息 * @param int $role_id * @return Ambigous <multitype:, boolean> */ public function getMeById($role_id) { $selectSql = new SelectSql($this->table); $selectSql->setWhere("id", $role_id); $selectSql->setOrder("id"); $selectSql->setLimitAndOffset(); return $selectSql->executeSelectSql($this->db); } /** * 获取所有的用户组 * @return array */ public function getMeAll() { $selectSql = new SelectSql($this->table); $selectSql->setOrder("sort"); return $selectSql->executeSelectSql($this->db, true); } /** * 获取小于或等于当前权限的用户组 * @param int $jurisdiction */ public function getMeAllByJurisdiction($jurisdiction) { $selectSql = new SelectSql($this->table); $selectSql->setWhere("jurisdiction", $jurisdiction, "<="); $selectSql->setOrder("sort"); return $selectSql->executeSelectSql($this->db, true); } /** * 修改角色属性 * @param int $id * @param string $name * @param int $sort * @param int $add_robot_max_number * @param int $init_gold * @param int $jurisdiction * @return boolean */ public function updateMe($id, $name, $sort, $add_robot_max_number, $init_gold, $jurisdiction) { $updateSql = new UpdateSql($this->table); $updateSql->setUpdateValue("name", $name); $updateSql->setUpdateValue("sort", $sort); $updateSql->setUpdateValue("add_robot_max_number", $add_robot_max_number); $updateSql->setUpdateValue("init_gold", $init_gold); $updateSql->setUpdateValue("jurisdiction", $jurisdiction); $updateSql->setWhere("id", $id); return $updateSql->executeUpdateSql($this->db); } /** * 根据角色ID删除角色信息 * @param int $id * @return boolean */ public function deleteMe($id) { $deleteSql = new DeleteSql($this->table); $deleteSql->setWhere("id", $id); return $deleteSql->executeDeleteSql($this->db); } /** * 添加新角色 * @param string $name * @param int $sort * @param int $add_robot_max_number * @param int $init_gold * @param int $jurisdiction * @return int */ public function insertMe($name, $sort, $add_robot_max_number, $init_gold, $jurisdiction) { $insertSql = new InsertSql($this->table); $columnArray = array( "name", "sort", "add_robot_max_number", "init_gold", "jurisdiction", "createdate" ); $columnValueArray = array( $name, $sort, $add_robot_max_number, $init_gold, $jurisdiction, time() ); $insertSql->setInsert($columnArray, $columnValueArray); return $insertSql->executeInsertSql($this->db); } } ?>